This is a text description of Figure 14-1, "Calling Oracle Stored Procedures in a Distributed Oracle Environment".

The functions illustrated in the figure are described in the surrounding text.

The figure shows an Oracle application calling two Oracle stored procedures (oraproc1 and oraproc2) from an Oracle server instance.

In the figure, the Oracle application is calling the two Oracle stored procedures through two separate Oracle server instances (ORA1 and ORA2) of the Oracle server database.

Procedure oraproc1, which is stored in instance ORA1, includes a statement that accesses a table in the ORA2 instance.

In this same manner, Oracle stored procedures can be used to access DB2 tables through the gateway.